************************************************************************************** .
*     Presidential Impeachment and the New Political Instability in Latin America    * .
*                 An�bal P�rez-Li��n, University of Pittsburgh, 2006                 * .
*                           Analysis for Chapters 1 and 3                            * .
************************************************************************************** .

*********************        Use file : 1_Chapter_3.sav    **********************      .

GET FILE='F:\Research\Research in Progress\Crises Without Breakdown\Book\Datasets\1_Chapter_3.sav'.


**        Chapter 1: Institutional Crises in Presidential Regimes                      .

** Number of presidential crises related to military interventions or coups, 1950-2004 .

WEIGHT BY NC .
* (Weights counts Brazil 1955 and Argentina 2001 as 2 events each and removes all years without a crisis) .
FREQUENCIES
  VARIABLES=COUP MIL
  /ORDER=  ANALYSIS .
WEIGHT OFF.

** Number of coups involving a presidential crisis , 1950-2004 .

CROSSTABS
  /TABLES=COUP by CRISIS
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT ROW 
  .



**        Chapter 3:  Presidential Crises and the Decline of Military Intervention                     .

** FIGURE 3-1 : Figures for Graph of Democratic Evolution .
MEANS
  TABLES=D DSD  BY Year
  /CELLS SUM  .

** TABLE 3-1 : RATE OF MILITARY COUPS BY DECADE  .
* a - All regimes, only successful coups .
CROSSTABS TABLES=DECADE  BY COUP  /FORMAT= AVALUE TABLES  /CELLS= COUNT ROW  /COUNT ROUND CELL .
* b - All regimes, successful and failed coups .
CROSSTABS TABLES=DECADE  BY MIL  /FORMAT= AVALUE TABLES  /CELLS= COUNT ROW  /COUNT ROUND CELL .
* c - Competitive regimes, only successful coups .
USE ALL.
COMPUTE filter_$=(DSD=1).
FILTER BY filter_$.
EXECUTE .
CROSSTABS TABLES=DECADE  BY COUP  /FORMAT= AVALUE TABLES  /CELLS= COUNT ROW  /COUNT ROUND CELL .
* d - Competitive, successful and failed coups .
CROSSTABS TABLES=DECADE  BY MIL  /FORMAT= AVALUE TABLES  /CELLS= COUNT ROW  /COUNT ROUND CELL .
USE ALL.

** TABLE 3-2 : Presidential Crises, 1950-2004 .
WEIGHT BY NC .
SUMMARIZE
  /TABLES=Country Year  BY MBP_C
  /FORMAT=VALIDLIST NOCASENUM TOTAL
  /TITLE='Table 3.2 Presidential Crises, by Type of Regime (1950-2004)'
  /MISSING=TABLE
  /CELLS=COUNT .
WEIGHT OFF.

** FIGURE 3-2 : Typology of Outcomes of Presidential Crises .
WEIGHT BY NC .
CROSSTABS
  /TABLES=TYPE  BY MIL
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .
WEIGHT OFF.

** TABLE 3-3 : Outcomes of Presidential Crises .
SORT CASES  BY IREG (A) ISEP (A) .
WEIGHT BY NC .
Report
  /FORMAT= CHWRAP(ON) PREVIEW(OFF) CHALIGN(BOTTOM)  UNDERSCORE(ON)
  ONEBREAKCOLUMN(OFF) CHDSPACE(1)  SUMSPACE(0)  AUTOMATIC  LIST
   BRKSPACE(-1)
  PAGE(1) MISSING'.' LENGTH(1, 100) ALIGN(LEFT) TSPACE(1) FTSPACE(1)
 MARGINS(1,49)
 /TITLE= 'Table 3.3 - Outcomes of Presidential Crises '
 /VARIABLES
 Country  (VALUES)  (LEFT)  (OFFSET(0)) (8)
 Year  (VALUES)  (RIGHT)  (OFFSET(0)) (8)
 /BREAK   IREG  (LABELS)  (LEFT)  (OFFSET(0)) (10)
 /BREAK   ISEP  (LABELS)  (LEFT)  (OFFSET(0)) (16).
WEIGHT OFF.
SORT CASES  BY country (A) year (A) .


** TABLE 3-4 : Percent of presidential crises involving a military intervention, before and after the Third Wave of Democratization .
**               --Third Wave (TW) cases are defined as all democracies or semi-democracies after 1977--                            .
WEIGHT BY NC .
CROSSTABS
  /TABLES=TW  BY IREG
  /TABLES=TW  BY ISEP
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT ROW
   .
WEIGHT OFF.

